package cc.iotkit.data.dao;

import cc.iotkit.data.model.TbWzrGwDevGroup;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface WzrGwDevGroupRepository extends JpaRepository<TbWzrGwDevGroup, Long> {

    @Query(value = "select g.gw_dev_group_name as gwDevGroupName,g.work_state as workState,g.percentage as percentage,g.gwid as gwid  from wzr_gw_dev_group g",nativeQuery = true)
    Page<TbWzrGwDevGroup> findAllByPag(Pageable pageable);
}